Merge Interval
Short Description
Merge Interval merges multiple possibly overlapping intervals (ranges) to produce one non-overlapping range with no duplicates
Detailed Description​
Merge Interval merges multiple possibly overlapping intervals (ranges) to produce one non-overlapping range with no duplicates. This is found in dynamic queries where the data is not known until run-time and can be found in queries with BETWEEN and OR operators in.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.